Diagram UHCContracts_8

Defincja diagramu UHCContracts_8

Name

UHCContracts_8

Code

UHCContracts_8

Comment

 


Lista tabel diagramu

Name

Code

AccountData

AccountData

AccountDataDrug

AccountDataDrug

AccountTemplate

AccountTemplate

Contract

Contract

ContractService

ContractService

DrugInvoice

DrugInvoice

EMail

EMail

ExcludedContractService

ExcludedContractService

Insurer

Insurer

Invoice

Invoice

InvoiceData

InvoiceData

InvoiceStatus

InvoiceStatus

InvoiceStatusError

InvoiceStatusError

InvoiceType

InvoiceType

LAccountTemplatePosition

LAccountTemplatePosition

LContContOrgUnit

LContContOrgUnit

LDeletedInvoice

LDeletedInvoice

LDrugInvoice

LDrugInvoice

LInvoice

LInvoice

LInvoiceAccountTemplate

LInvoiceAccountTemplate

LInvoicePosition

LInvoicePosition

LInvoicePositionPOZInfo

LInvoicePositionPOZInfo

Message

Message

MessageType

MessageType

OrgUnit

OrgUnit

PaymentType

PaymentType

PozConnectedCareProvider

PozConnectedCareProvider

PozConnectedContract

PozConnectedContract

TempId

TempId


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_151

R_151

Contract

Invoice

ContractID

 

 

R_152

R_152

InvoiceData

Invoice

InvoiceDataID

 

 

R_153

R_153

InvoiceType

Invoice

InvoiceTypeID

 

 

R_154

R_154

PaymentType

Invoice

PaymentTypeID

 

 

R_155

R_155

Invoice

LInvoice

InvoiceID

 

 

R_156

R_156

Invoice

LInvoice

Inv_InvoiceID

 

 

R_157

R_157

ContractService

LInvoicePosition

ContractServID

 

 

R_158

R_158

Invoice

LInvoicePosition

InvoiceID

 

 

R_192

R_192

AccountTemplate

Invoice

AccountTemplateID

 

 

R_250

R_250

Invoice

InvoiceStatus

InvoiceID

 

 

R_251

R_251

Message

InvoiceStatus

MessageID

 

 

R_252

R_252

InvoiceStatus

InvoiceStatusError

InvoiceStatusID

 

 

R_260

R_260

DrugInvoice

InvoiceStatus

DrugInvoiceID

 

 

R_261

R_261

InvoiceStatus

DrugInvoice

InvoiceStatusID

 

 

R_280

R_280

Invoice

LInvoiceAccountTemplate

InvoiceID

 

 

R_281

R_281

AccountTemplate

LInvoiceAccountTemplate

AccountTemplateID

 

 

R_283

R_283

ContractService

LInvoicePositionPOZInfo

Con_ContractServID

 

 

R_301

R_301

Invoice

LDeletedInvoice

InvoiceID

 

 

R_313

R_313

Contract

LContContOrgUnit

ContractID

 

 

R_314

R_314

ContractService

LContContOrgUnit

ContractServID

 

 

R_315

R_315

OrgUnit

LContContOrgUnit

OrgUnitID

 

 

R_316

R_316

Contract

LContContOrgUnit

Con_ContractID

 

 

R_370

R_370

Contract

AccountData

ContractID

 

 

R_380

R_380

Message

EMail

MessageID

 

 

R_390

R_390

MessageType

EMail

MessageTypeID

 

 

R_420

R_420

Insurer

LInvoicePositionPOZInfo

InsurerID

 

 

R_510

R_510

Contract

ExcludedContractService

ContractID

 

 

R_511

R_511

ContractService

ExcludedContractService

ContractServID

 

 

R_512

R_512

ContractService

ExcludedContractService

Con_ContractServID

 

 

R_565

R_565

ContractService

LAccountTemplatePosition

Con_ContractServiceID

 

 

R_566

R_566

AccountTemplate

LAccountTemplatePosition

AccountTemplateID

 

 

R_581

R_581

AccountData

AccountDataDrug

AccountDataID

 

 

R_590

R_590

DrugInvoice

LDrugInvoice

DrugInvoiceID

 

 

R_591

R_591

DrugInvoice

LDrugInvoice

Inv_InvoiceID

 

 

R_592

R_592

ContractService

LAccountTemplatePosition

ContractServiceID

 

 

R_603

R_603

LAccountTemplatePosition

PozConnectedCareProvider

LAccountTemplatePositionID

 

 

R_604

R_604

PozConnectedCareProvider

PozConnectedContract

PozConnectedCareProviderID